ORACLE 输出1-10数字循环答:create table student (id number(2),name varchar2(20));insert into student values (1,'A,B,C');insert into student values (2,'D,E');commit;select distinct id, regexp_substr(name, '[^,]+', 1, level) name from student connect by level <= length(name) - length(replace...
怎么oracle数据库里一个字段的值拆分成两个值分别保存答:with temp as (select name as text from a )select substr(text,instr(text,',',1,rn)+1,instr(text,',',1,rn+1)-instr(text,',',1,rn)-1) text from (select ','||t1.text||',' text,t2.rn from (select text,length(text)-length(replace(text,',',''))+1 rn from ...
oracle 存储过程 求助答:V_TEMPSQL := SUBSTR(buffer, V_BSF, length(buffer) - V_BSF + 1);--注:从buffer中截取字符串 buffer := SUBSTR(buffer, 1, V_BSF);V_STEP := 1;loop V_NUMBER1 := INSTR(buffer, CHR(10), 1, V_STEP);V_NUMBER2 := INSTR(buffer, CHR(10), 1, V_STEP + 1);...